Python Job: Data Modeller

About us

Transport for NSW keeps our State moving by providing safe, integrated and efficient transport systems. We put our customers at the centre of everything we do – and we do a lot. We connect people, communities and industry and manage how they use our road, rail and maritime networks and services, and even active modes like walking and cycling. The work we do connects the journeys you take every day.

We are a state government organisation made up of more than 28,000 people and we're in the middle of delivering the largest transport infrastructure program in Australia's history. We work across planning, policy and procurement, harnessing data and technology to develop smarter and more adaptive transport solutions.

That means job opportunities in metropolitan and regional areas right across NSW – you have the chance to be part of creating a lasting legacy that will benefit generations to come.

The Division

We are a trusted partner to our clients, within Customer Strategy and Technology, developing and delivering smart, integrated and sustainable data and analytics solutions which enable evidence-driven decisions to benefit our customers and communities, and leading an uplift in data literacy of use of data insights across the cluster.

The opportunity

Right now, we have an exciting opportunity for a Data Modeller to join us in Data Engineering & Architecture team. It is responsible for developing conceptual, logical, and physical data models for databases and data warehouses, and ensure high data quality and less redundancy while also working with data architects and analyse business requirements, implement data strategies as well as optimise, and update data models.

The role requires strong business stakeholder management ability to ensure stability of the AAI team through its growth.

What you will be involved in but not limited to:

• Create, optimise, update, and maintain conceptual, logical and physical data models in various RDBMS, NoSQL and Data Lake environments.
• Analysing and translating the data modelling needs of the branch in terms of Business Intelligence, Analytics and Data Science use cases to understand how teams are leveraging the data models to derive business and customer insights.
• Evaluating data systems for their veracity, variety, value, velocity and volume to apply the most correct data modelling technique appropriate to the source and its application.
• Work collaboratively in a diverse team environment, including data architects and developers as well as understanding and translating business needs into high-level conceptual data models, data strategies and data flows as required.
• Effectively collaborate with database administrators in creating physical data schema from the logical and physical data models by making recommendations, designing referential integrity, and ensuring compliance with business requirements.
• Design and develop data mapping, code and transformation scripts to support and promote Data Lake / Data Warehouse / RDBMS deliverables as well as design effective ELT logic and code as required.
• Define and govern data modelling and design standards, tools, best practices and related development methodologies as required as well as utilising data modelling tools and associated graphical methods to depict and analyse conceptual, logical and physical data schemas.
• Evaluate data models, business data objects and physical databases and troubleshooting or resolving related issues as well as making recommendations for proper usage or re-use of data models in different environments.

About you:

• Working with in big data environments with genuine big data challenges and effectively managing the technical trade-offs between Data Lake, OLAP, OLTP with an understanding of scalability, supportability and performance challenges.
• Experience with modelling data for RDBMS using tools such as ERWIN data modeler or Sparx Enterprise Architect or Lean IX.
• Exposure in reverse engineering of physical data models from databases and SQL scripts.
• Deep understanding of AWS S3 Data Lake, Data Warehouse and experience in working with dynamic geospatial data and linear asset management systems.
• Excellent stakeholder engagement and management skills.
• Ability to influence and quickly build relationships.
• Working knowledge of Python and other cloud first scripting languages for the purposes of automation and process scheduling is a big bonus.

Want to know more?

Please click here to view a copy of the role description.

Interested?

Right now is an exciting time to join our team as we deliver an iconic $72.2 billion investment into future transport infrastructure and services over 40 years.

Be a part of something big. Apply today to register your interest!

Find out more about Transport for NSW at https://www.transport.nsw.gov.au/about-us.


Salary and Benefits

The salary for this position is TfNSW Grade 8 ($118,015 - $132,176) per annum plus superannuation and leave loading.


How to apply

To apply for this position, please submit a resume and address the questions within the application.


Application Close date: 11:59pm Monday 24 October 2022

We are the community we serve

We are committed to being an inclusive, diverse and flexible workplace where differences are valued. We welcome people of all backgrounds, experience and abilities.

We enable our people to work in ways that work for them with flexible work policies, offerings and practices. Working virtually and from different locations including regional locations, staggering work hours and job sharing are just some of the ways our people can work flexibly. We’re proud to be recognised as a FlexReady Certified employer and winners of the ‘Best Remote Work Strategy’ for our hybrid ways of working at the Australian HR Awards 2022.

Please contact the Talent Specialist below if you require any adjustments to be made to how you interact with us throughout the recruitment process or would like to discuss flexible work options.

For any enquiries, please email Aleni Togafau at [email protected].

Learn more about how Transport supports people with disability and those providing care via Transport Careers Supporting People with Disability page.

We’re certified as a Family Inclusive Workplace

Our flexible work practices and policies for parental leave, employee and family wellbeing and family care enable us to provide genuine support for our people to thrive at work and at home.

Working with Transport gives you access to a range of benefits that help you balance work with the things that matter to you. Look through our Employee Benefits Guide to learn more.

Apply today to register your interest!

Find out more about Transport for NSW at https://www.transport.nsw.gov.au/about-us.

Take a look at our application tips video series for plenty of great information on navigating and acing the application and recruitment process here at Transport.
#LI-Hybrid